Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 12 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 1 | maybe slow |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 1 | maybe slow |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Post`.`id`, `Post`.`catpost_id`, `Post`.`title`, `Post`.`slug`, `Post`.`image`, `Post`.`des`, `Post`.`content`, `Post`.`public`, `Post`.`hot`, `Post`.`star`, `Post`.`slide`, `Post`.`new`, `Post`.`know`, `Post`.`titleseo`, `Post`.`description`, `Post`.`keywords`, `Post`.`created`, `Post`.`modified` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`slug` = 'bao-cao-tai-chinh-6-thang-dau-nam-2022' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Catpost`.`id`, `Catpost`.`parent_id`, `Catpost`.`lft`, `Catpost`.`rght`, `Catpost`.`name`, `Catpost`.`slug`, `Catpost`.`folder`, `Catpost`.`image`, `Catpost`.`type`, `Catpost`.`public`, `Catpost`.`home`, `Catpost`.`menu`, `Catpost`.`search`, `Catpost`.`des`, `Catpost`.`content`, `Catpost`.`order`, `Catpost`.`titleseo`, `Catpost`.`description`, `Catpost`.`keywords`, `Catpost`.`created`, `Catpost`.`modified`, `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id` FROM `admin_tlqn2021`.`catposts` AS `Catpost` JOIN `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` ON (`CatpostsPost`.`post_id` = 105 AND `CatpostsPost`.`catpost_id` = `Catpost`.`id`) | 1 | 1 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` WHERE `CatpostsPost`.`post_id` = 105 | 1 | 1 | 0 | |
SELECT `CatpostsPost`.`id`, `CatpostsPost`.`catpost_id`, `CatpostsPost`.`post_id` FROM `admin_tlqn2021`.`catposts_posts` AS `CatpostsPost` WHERE `CatpostsPost`.`catpost_id` = (38) LIMIT 10 | 7 | 7 | 0 | |
SELECT `Post`.`title`, `Post`.`slug`, `Post`.`modified` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`id` IN (99, 101, 102, 103, 104, 105, 106) ORDER BY `Post`.`modified` desc | 6 | 6 | 0 | |
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 10 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Insertcode`.`id`, `Insertcode`.`user_id`, `Insertcode`.`title`, `Insertcode`.`content`, `Insertcode`.`public`, `Insertcode`.`pos_top`, `Insertcode`.`pos_footer`, `Insertcode`.`created`, `Insertcode`.`modified` FROM `admin_tlqn2021`.`insertcodes` AS `Insertcode` WHERE `Insertcode`.`pos_top` = '1' AND `Insertcode`.`public` = '1' | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `admin_tlqn2021`.`counters` AS `Counter` WHERE 1 = 1 | 1 | 1 | 10 | maybe slow |
SELECT `Setting`.* FROM `admin_tlqn2021`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.* FROM `admin_tlqn2021`.`banners` AS `Banner` WHERE `Banner`.`pos_right` = '1' AND `Banner`.`public` = '1' ORDER BY `Banner`.`modified` desc | 3 | 3 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` IS NULL AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Post`.`title`, `Post`.`slug` FROM `admin_tlqn2021`.`posts` AS `Post` WHERE `Post`.`public` = '1' AND `Post`.`know` = '1' ORDER BY `Post`.`modified` desc LIMIT 10 | 5 | 5 | 0 | |
SELECT `Video`.* FROM `admin_tlqn2021`.`videos` AS `Video` WHERE `Video`.`public` = '1' AND `Video`.`sidebar` = '1' ORDER BY `Video`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 3 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 0 | 0 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 13 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 4 | 4 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 10 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 9 | 9 | 0 | |
SELECT `Catpost`.* FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`parent_id` = 4 AND `Catpost`.`menu` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Catpost`.`id`, `Catpost`.`name` FROM `admin_tlqn2021`.`catposts` AS `Catpost` WHERE `Catpost`.`public` = '1' AND `Catpost`.`search` = '1' ORDER BY `Catpost`.`order` asc | 5 | 5 | 0 | |
SELECT `Insertcode`.`id`, `Insertcode`.`user_id`, `Insertcode`.`title`, `Insertcode`.`content`, `Insertcode`.`public`, `Insertcode`.`pos_top`, `Insertcode`.`pos_footer`, `Insertcode`.`created`, `Insertcode`.`modified` FROM `admin_tlqn2021`.`insertcodes` AS `Insertcode` WHERE `Insertcode`.`pos_footer` = '1' AND `Insertcode`.`public` = '1' | 0 | 0 | 0 | |
22 duplicate queries run.